CREATE EXTERNAL TABLE IF NOT EXISTS jms_ods.laiqu_self_pickup(
id                                                 bigint                         COMMENT '',
version                                            bigint                         COMMENT '',
createTime                                         String                         COMMENT '创建时间即入库时间',
lastUpdateTime                                     String                         COMMENT '',
spCode                                             String                         COMMENT '服务商编码',
serviceSiteCode                                    String                         COMMENT '服务点编码',
appUserId                                          String                         COMMENT '用户ID',
expressCompanyCode                                 String                         COMMENT '快递公司编码',
billCode                                           String                         COMMENT '单号',
receiverPhone                                      String                         COMMENT '收件人号码',
receiverName                                       String                         COMMENT '收件人姓名',
phoneSource                                        String                         COMMENT '号码来源',
phoneLastFour                                      String                         COMMENT '号码后4位',
scanTime                                           String                         COMMENT '扫描时间',
pickupTime                                         String                         COMMENT '出库时间拒收时间',
statusCode                                         bigint                         COMMENT '状态',
shelfName                                          String                         COMMENT '货架名称',
shelfNumber                                        String                         COMMENT '货架编号',
pickupType                                         String                         COMMENT '取件类型',
pickupData                                         String                         COMMENT '取件数据',
rejectReason                                       String                         COMMENT '拒收原因',
remark                                             String                         COMMENT '备注,是否取消签收|是否移库过',
transactionCode                                    String                         COMMENT '菜鸟用',
billCodeLastFour                                   String                         COMMENT '单号后4位',
goodsNumber                                        String                         COMMENT '取件码（货号）'
)
COMMENT ''
PARTITIONED BY (dt STRING COMMENT '更新/创建日期 (yyyy-MM-dd)')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/laiqu_self_pickup'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
);